----------------------------------------------------------------------------------
      name:  <unnamed>
       log:  G:\My Drive\Research\CTC expansion\submission\ntj\stata replication f
> iles/output/table1.log
  log type:  text
 opened on:   3 Dec 2023, 18:17:23

. 
. version 16      

. 
. use "$data\acsmergeddata.dta", clear

. 
. gen spmdeeppoor=(spm_resources<spm_povthreshold/2)

. 
. gen famincog=faminc

. gen faminceitc=faminc+v25

. gen famincctc17=faminc+totctc2017

. gen famincctc18=faminc+totctc2018

. gen faminceitcctc17=famincctc17+v25

. gen faminceitcctc18=famincctc18+v25

. gen faminceitcctc21=famincctc21+v25

. 
. foreach var in og ctc21 ctc18 ctc17 eitc eitcctc17 eitcctc18 eitcctc21{
  2.         gen pr`var'=(faminc`var'<spm_povthreshold)      
  3.         gen dppr`var'=(faminc`var'<(spm_povthreshold/2))
  4. }

. 
. foreach var in ctc21 ctc17 ctc18 eitc eitcctc17 eitcctc18 eitcctc21{
  2.         gen nomasprog`var'=(prog==1 & pr`var'==0)
  3.         gen stillprog`var'=(prog==1 & pr`var'==1)
  4. 
.         gen nomasdpprog`var'=(dpprog==1 & dppr`var'==0)
  5.         gen stilldpprog`var'=(dpprog==1 & dppr`var'==1)
  6. }

. sum nomas*pr*

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
nomasprogc~1 |    356,390    .0267488    .1613486          0          1
n~pprogctc21 |    356,390     .013401    .1149848          0          1
nomasprogc~7 |    356,390    .0066472    .0812591          0          1
n~pprogctc17 |    356,390    .0013581    .0368269          0          1
nomasprogc~8 |    356,390    .0088583    .0937007          0          1
-------------+---------------------------------------------------------
n~pprogctc18 |    356,390    .0016751    .0408941          0          1
nomasproge~c |    356,390    .0176211    .1315701          0          1
nomasdppro~c |    356,390    .0044474    .0665403          0          1
nomasproge~7 |    356,390    .0223407    .1477892          0          1
nomasdppro.. |    356,390    .0050619    .0709666          0          1
-------------+---------------------------------------------------------
nomasproge~8 |    356,390    .0237493    .1522672          0          1
nomasdppro.. |    356,390    .0052443    .0722272          0          1
nomasproge~1 |    356,390    .0403126    .1966916          0          1
nomasdppro.. |    356,390    .0158057    .1247235          0          1

. sum still*pr*   

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
stillprogc~1 |    356,390    .0701843    .2554578          0          1
s~pprogctc21 |    356,390    .0180224    .1330325          0          1
stillprogc~7 |    356,390    .0902859    .2865914          0          1
s~pprogctc17 |    356,390    .0300654    .1707675          0          1
stillprogc~8 |    356,390    .0880749    .2834041          0          1
-------------+---------------------------------------------------------
s~pprogctc18 |    356,390    .0297483    .1698924          0          1
stillproge~c |    356,390     .079312    .2702255          0          1
stilldppro~c |    356,390    .0269761    .1620137          0          1
stillproge~7 |    356,390    .0745924    .2627329          0          1
stilldppro.. |    356,390    .0263616    .1602083          0          1
-------------+---------------------------------------------------------
stillproge~8 |    356,390    .0731839    .2604384          0          1
stilldppro.. |    356,390    .0261792    .1596681          0          1
stillproge~1 |    356,390    .0566206    .2311165          0          1
stilldppro.. |    356,390    .0156177    .1239913          0          1

. 
. gen pop=(perwt + spouseperwt)

. egen totadults=sum(pop)

. di totadults
63164152

. drop pop

. 
. gen pop=(newnumkidswt17)

. egen totkids=sum(pop)

. di totkids
72755400

. drop pop

. 
. *** total SPM poor
. gen pop=(perwt + spouseperwt)*spm_poor

. egen poortotadults=sum(pop)

. di poortotadults
8009924

. drop pop poortotadults

. 
. gen pop=(newnumkidswt17)*spm_poor

. egen poortotkids=sum(pop)

. di poortotkids
11789952

. drop pop poortotkids

. 
. *** total SPM deep poor
. gen pop=(perwt + spouseperwt)*spmdeeppoor

. egen deeppoortotadults=sum(pop)

. di deeppoortotadults
2078788

. drop pop deeppoortotadults

. 
. gen pop=(newnumkidswt17)*spmdeeppoor

. egen deeppoortotkids=sum(pop)

. di deeppoortotkids
3158955.5

. drop pop deeppoortotkids

. 
. *** total poor without CTC or EITC
. gen pop=(perwt + spouseperwt)*poor

. egen poortotadults=sum(pop)

. di poortotadults
7558882

. drop pop

. 
. gen pop=(newnumkidswt17)*poor

. egen poortotkids=sum(pop)

. di poortotkids
11176950

. drop pop

. 
. *** total poor without CTC or EITC
. gen pop=(perwt + spouseperwt)*dpprog

. egen deeppoortotadults=sum(pop)

. di deeppoortotadults
1663712

. drop pop

. 
. gen pop=(newnumkidswt17)*dpprog

. egen deeppoortotkids=sum(pop)

. di deeppoortotkids
2511355.5

. drop pop

. 
. ***************************************************************************
. *** parents and kids pulled out of poverty and deep poverty by the EITC
. ***************************************************************************
. 
. forvalues i=1/3{
  2. gen parents`i'=(perwt+spouseperwt)*(nomasprogeitc)*(calckids==`i')
  3. egen totparents`i'=sum(parents`i')
  4. drop parents`i'
  5. }

. di totparents1+totparents2+totparents3
1109734

. di (totparents1+totparents2+totparents3)/poortotadults
.14681192

. drop totparents1 totparents2 totparents3

. 
. forvalues i=1/3{
  2. gen parents`i'=(newnumkidswt17)*(nomasprogeitc)*(calckids==`i')
  3. egen totparents`i'=sum(parents`i')
  4. drop parents`i'
  5. }

. di totparents1+totparents2+totparents3
1646422

. di (totparents1+totparents2+totparents3)/poortotkids
.14730512

. drop totparents1 totparents2 totparents3

. 
. forvalues i=1/3{
  2. gen parents`i'=(perwt+spouseperwt)*(nomasdpprogeitc)*(calckids==`i')
  3. egen totparents`i'=sum(parents`i')
  4. drop parents`i'
  5. }

. di totparents1+totparents2+totparents3
248458

. di (totparents1+totparents2+totparents3)/deeppoortotadults
.14933955

. drop totparents1 totparents2 totparents3

. 
. forvalues i=1/3{
  2. gen parents`i'=(newnumkidswt17)*(nomasdpprogeitc)*(calckids==`i')
  3. egen totparents`i'=sum(parents`i')
  4. drop parents`i'
  5. }

. di totparents1+totparents2+totparents3
366647.5

. di (totparents1+totparents2+totparents3)/deeppoortotkids
.14599586

. drop totparents1 totparents2 totparents3

. 
. ***************************************************************************
. *** parents and kids pulled out of poverty and deep poverty by the 2017 CTC
. ***************************************************************************
. 
. forvalues i=1/3{
  2. gen parents`i'=(perwt+spouseperwt)*(nomasprogctc17)*(calckids==`i')
  3. egen totparents`i'=sum(parents`i')
  4. drop parents`i'
  5. }

. di totparents1+totparents2+totparents3
428349

. di (totparents1+totparents2+totparents3)/poortotadults
.0566683

. drop totparents1 totparents2 totparents3

. 
. forvalues i=1/3{
  2. gen parents`i'=(newnumkidswt17)*(nomasprogctc17)*(calckids==`i')
  3. egen totparents`i'=sum(parents`i')
  4. drop parents`i'
  5. }

. di totparents1+totparents2+totparents3
640190

. di (totparents1+totparents2+totparents3)/poortotkids
.0572777

. drop totparents1 totparents2 totparents3

. 
. forvalues i=1/3{
  2. gen parents`i'=(perwt+spouseperwt)*(nomasdpprogctc17)*(calckids==`i')
  3. egen totparents`i'=sum(parents`i')
  4. drop parents`i'
  5. }

. di totparents1+totparents2+totparents3
77001

. di (totparents1+totparents2+totparents3)/deeppoortotadults
.04628265

. drop totparents1 totparents2 totparents3

. 
. forvalues i=1/3{
  2. gen parents`i'=(newnumkidswt17)*(nomasdpprogctc17)*(calckids==`i')
  3. egen totparents`i'=sum(parents`i')
  4. drop parents`i'
  5. }

. di totparents1+totparents2+totparents3
110654.5

. di (totparents1+totparents2+totparents3)/deeppoortotkids
.04406166

. drop totparents1 totparents2 totparents3

. 
. ***************************************************************************
. *** parents and kids pulled out of poverty and deep poverty by the 2018 CTC
. ***************************************************************************
. 
. forvalues i=1/3{
  2. gen parents`i'=(perwt+spouseperwt)*(nomasprogctc18)*(calckids==`i')
  3. egen totparents`i'=sum(parents`i')
  4. drop parents`i'
  5. }

. di totparents1+totparents2+totparents3
571488

. di (totparents1+totparents2+totparents3)/poortotadults
.07560483

. drop totparents1 totparents2 totparents3

. 
. forvalues i=1/3{
  2. gen parents`i'=(newnumkidswt17)*(nomasprogctc18)*(calckids==`i')
  3. egen totparents`i'=sum(parents`i')
  4. drop parents`i'
  5. }

. di totparents1+totparents2+totparents3
809827

. di (totparents1+totparents2+totparents3)/poortotkids
.0724551

. drop totparents1 totparents2 totparents3

. 
. forvalues i=1/3{
  2. gen parents`i'=(perwt+spouseperwt)*(nomasdpprogctc18)*(calckids==`i')
  3. egen totparents`i'=sum(parents`i')
  4. drop parents`i'
  5. }

. di totparents1+totparents2+totparents3
93810

. di (totparents1+totparents2+totparents3)/deeppoortotadults
.05638596

. drop totparents1 totparents2 totparents3

. 
. forvalues i=1/3{
  2. gen parents`i'=(newnumkidswt17)*(nomasdpprogctc18)*(calckids==`i')
  3. egen totparents`i'=sum(parents`i')
  4. drop parents`i'
  5. }

. di totparents1+totparents2+totparents3
130494.5

. di (totparents1+totparents2+totparents3)/deeppoortotkids
.05196178

. drop totparents1 totparents2 totparents3

. 
. ***************************************************************************
. *** parents and kids pulled out of poverty and deep poverty by the 2021 CTC
. ***************************************************************************
. 
. forvalues i=1/3{
  2. gen parents`i'=(perwt+spouseperwt)*(nomasprogctc21)*(calckids==`i')
  3. egen totparents`i'=sum(parents`i')
  4. drop parents`i'
  5. }

. di totparents1+totparents2+totparents3
1515582

. di (totparents1+totparents2+totparents3)/poortotadults
.20050346

. drop totparents1 totparents2 totparents3

. 
. forvalues i=1/3{
  2. gen parents`i'=(newnumkidswt17)*(nomasprogctc21)*(calckids==`i')
  3. egen totparents`i'=sum(parents`i')
  4. drop parents`i'
  5. }

. di totparents1+totparents2+totparents3
2997498

. di (totparents1+totparents2+totparents3)/poortotkids
.26818569

. drop totparents1 totparents2 totparents3

. 
. forvalues i=1/3{
  2. gen parents`i'=(perwt+spouseperwt)*(nomasdpprogctc21)*(calckids==`i')
  3. egen totparents`i'=sum(parents`i')
  4. drop parents`i'
  5. }

. di totparents1+totparents2+totparents3
699834

. di (totparents1+totparents2+totparents3)/deeppoortotadults
.42064612

. drop totparents1 totparents2 totparents3

. 
. forvalues i=1/3{
  2. gen parents`i'=(newnumkidswt17)*(nomasdpprogctc21)*(calckids==`i')
  3. egen totparents`i'=sum(parents`i')
  4. drop parents`i'
  5. }

. di totparents1+totparents2+totparents3
1370788

. di (totparents1+totparents2+totparents3)/deeppoortotkids
.5458359

. drop totparents1 totparents2 totparents3

. 
. ***************************************************************************
. *** parents and kids pulled out of poverty and deep poverty by the 2017 CTC + EI
> TC
. ***************************************************************************
. 
. forvalues i=1/3{
  2. gen parents`i'=(perwt+spouseperwt)*(nomasprogeitcctc17)*(calckids==`i')
  3. egen totparents`i'=sum(parents`i')
  4. drop parents`i'
  5. }

. di totparents1+totparents2+totparents3
1405119

. di (totparents1+totparents2+totparents3)/poortotadults
.18588979

. drop totparents1 totparents2 totparents3

. 
. forvalues i=1/3{
  2. gen parents`i'=(newnumkidswt17)*(nomasprogeitcctc17)*(calckids==`i')
  3. egen totparents`i'=sum(parents`i')
  4. drop parents`i'
  5. }

. di totparents1+totparents2+totparents3
2068866

. di (totparents1+totparents2+totparents3)/poortotkids
.18510112

. drop totparents1 totparents2 totparents3

. 
. forvalues i=1/3{
  2. gen parents`i'=(perwt+spouseperwt)*(nomasdpprogeitcctc17)*(calckids==`i')
  3. egen totparents`i'=sum(parents`i')
  4. drop parents`i'
  5. }

. di totparents1+totparents2+totparents3
280825

. di (totparents1+totparents2+totparents3)/deeppoortotadults
.16879424

. drop totparents1 totparents2 totparents3

. 
. forvalues i=1/3{
  2. gen parents`i'=(newnumkidswt17)*(nomasdpprogeitcctc17)*(calckids==`i')
  3. egen totparents`i'=sum(parents`i')
  4. drop parents`i'
  5. }

. di totparents1+totparents2+totparents3
412708.5

. di (totparents1+totparents2+totparents3)/deeppoortotkids
.16433695

. drop totparents1 totparents2 totparents3

. 
. ***************************************************************************
. *** parents and kids pulled out of poverty and deep poverty by the EITC + 2018 C
> TC
. ***************************************************************************
. 
. forvalues i=1/3{
  2. gen parents`i'=(perwt+spouseperwt)*(nomasprogeitcctc18)*(calckids==`i')
  3. egen totparents`i'=sum(parents`i')
  4. drop parents`i'
  5. }

. di totparents1+totparents2+totparents3
1496985

. di (totparents1+totparents2+totparents3)/poortotadults
.19804318

. drop totparents1 totparents2 totparents3

. 
. forvalues i=1/3{
  2. gen parents`i'=(newnumkidswt17)*(nomasprogeitcctc18)*(calckids==`i')
  3. egen totparents`i'=sum(parents`i')
  4. drop parents`i'
  5. }

. di totparents1+totparents2+totparents3
2170999

. di (totparents1+totparents2+totparents3)/poortotkids
.19423895

. drop totparents1 totparents2 totparents3

. 
. forvalues i=1/3{
  2. gen parents`i'=(perwt+spouseperwt)*(nomasdpprogeitcctc18)*(calckids==`i')
  3. egen totparents`i'=sum(parents`i')
  4. drop parents`i'
  5. }

. di totparents1+totparents2+totparents3
292821

. di (totparents1+totparents2+totparents3)/deeppoortotadults
.17600462

. drop totparents1 totparents2 totparents3

. 
. forvalues i=1/3{
  2. gen parents`i'=(newnumkidswt17)*(nomasdpprogeitcctc18)*(calckids==`i')
  3. egen totparents`i'=sum(parents`i')
  4. drop parents`i'
  5. }

. di totparents1+totparents2+totparents3
425911.5

. di (totparents1+totparents2+totparents3)/deeppoortotkids
.16959427

. drop totparents1 totparents2 totparents3

. 
. ***************************************************************************
. *** parents and kids pulled out of poverty and deep poverty by the EITC + 2021 C
> TC
. ***************************************************************************
. 
. forvalues i=1/3{
  2. gen parents`i'=(perwt+spouseperwt)*(nomasprogeitcctc21)*(calckids==`i')
  3. egen totparents`i'=sum(parents`i')
  4. drop parents`i'
  5. }

. di totparents1+totparents2+totparents3
2353382

. di (totparents1+totparents2+totparents3)/poortotadults
.31133996

. drop totparents1 totparents2 totparents3

. 
. forvalues i=1/3{
  2. gen parents`i'=(newnumkidswt17)*(nomasprogeitcctc21)*(calckids==`i')
  3. egen totparents`i'=sum(parents`i')
  4. drop parents`i'
  5. }

. di totparents1+totparents2+totparents3
4105914

. di (totparents1+totparents2+totparents3)/poortotkids
.3673555

. drop totparents1 totparents2 totparents3

. 
. forvalues i=1/3{
  2. gen parents`i'=(perwt+spouseperwt)*(nomasdpprogeitcctc21)*(calckids==`i')
  3. egen totparents`i'=sum(parents`i')
  4. drop parents`i'
  5. }

. di totparents1+totparents2+totparents3
829677

. di (totparents1+totparents2+totparents3)/deeppoortotadults
.49869028

. drop totparents1 totparents2 totparents3

. 
. forvalues i=1/3{
  2. gen parents`i'=(newnumkidswt17)*(nomasdpprogeitcctc21)*(calckids==`i')
  3. egen totparents`i'=sum(parents`i')
  4. drop parents`i'
  5. }

. di totparents1+totparents2+totparents3
1515848

. di (totparents1+totparents2+totparents3)/deeppoortotkids
.60359754

. drop totparents1 totparents2 totparents3

. 
. log close
      name:  <unnamed>
       log:  G:\My Drive\Research\CTC expansion\submission\ntj\stata replication f
> iles/output/table1.log
  log type:  text
 closed on:   3 Dec 2023, 18:17:28
----------------------------------------------------------------------------------
